# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月20日
"""
import openpyxl
import random

myBook = openpyxl.load_workbook('录取表.xlsx')
mySheet=myBook.active
myNewBook=openpyxl.Workbook()
myNewSheet=myNewBook.active
myNewSheet.title='录取表'
myRowIndex=1
for myCell in list(mySheet.columns)[0]:
	myNewSheet.cell(myRowIndex,1).value=myCell.value
	myRowIndex+=1

myCols=list(mySheet.columns)[1:]
random.shuffle(myCols)
myColIndex=2
for myCol in myCols:
	myRowIndex=1
	for myCell in myCol:
		myNewSheet.cell(myRowIndex,myColIndex).value=myCell.value
		myRowIndex+=1
	myColIndex+=1
myNewBook.save('结果表-录取表.xlsx')
